Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

Schema holder database

A schema holder database is an OpenEdge database that holds information about the schema of the non-OpenEdge database, such as the names of tables and the offsets of where particular fields or columns begin. The DataServer only accesses the schema holder the first time a table on the non-OpenEdge database is accessed. In a run-time environment, new and modified data are not stored in the schema holder database. Instead, the new and modified data are stored in the non-OpenEdge database. Therefore, the schema holder database usually is connected as read-only. Connecting read-only allows you to access the schema holder database slightly faster and improves performance.

Caution: In a Progress Dynamics environment, OpenEdge does not support combining into a single OpenEdge database the tables and data for the schema holder and the tables and data for the Repository. The main drawback to that implementation is the loss of both environments if one becomes corrupted. For example, if the schema holder data and the Repository data are stored in one database and there is a problem, such as corruption, then both the schema holder and the Repository must be restored.